package sundun.sharding.mapper;



import com.baomidou.mybatisplus.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import sundun.sharding.entity.ImsYesterdayAjxx;

import java.util.List;
import java.util.Map;


/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author mhj
 * @since 2019-12-17
 */
@Mapper
public interface ImsYesterdayAjxxDao extends BaseMapper<ImsYesterdayAjxx> {


    @Select({"SELECT t1.* FROM ims_yesterday_ajxx t1 left join ims_sys_center_org t2 on t1.cbdwBh = t2.orgCode WHERE ( t1.zbrSfzh = '420101196303194381' or t1.xbrSfzh LIKE CONCAT('%','420101196303194381','%') ) and t1.slsj >= '2024-09-24 10:08:00'"})
    List<ImsYesterdayAjxx> getAllAjxx();


    Integer insert(ImsYesterdayAjxx ajxx);

    ImsYesterdayAjxx getAjxxByAjbh(@Param("ajbh") String ajbh);

    @Select({"select count(1) from ims_yesterday_ajxx t1 left join ims_sys_center_org t2 on t1.cbdwBh = t2.orgCode"})
    int getAllAjxx1();



    public Map<String, Object> getWdjClqk();


    @Select({"SELECT * FROM ims_yesterday_ajxx where slsj >= '2024-09-24 10:08:00'"})
    List<ImsYesterdayAjxx> getAllAjxx2();


}
